Summarizing CDM statistics to financial

To use your Charge Master (CDMCODE) to create your statistics, we offer a save-to-database utility that summarizes the Inpatient and Outpatient volumes in the RevUsage database (ACT_RU_20XX) into statistic accounts that can be stored in the Financial database (ACT20XX). For this utility to work, your Kaufman Hall consultant will help you design your CDMCODE table during the implementation process. For more information, see Setting up CDM Summarization.

To summarize CDM statistics to financial:

To run this Save to Database utility, navigate to In the Explorertask pane, in the Libraries section, click the Reports Library > Management Reporting Utilities > RevUsage folder, and double-click Summarize CDM Statistics.
In the drop down box in cell M19, select whether you are running the process for Current Year or Last Year.
Refresh the data by doing one of the following:
- In the Main ribbon tab, click Refresh Data.
- Press F9.
TIP: After you initially configure the CDM settings, we recommend that you test with just one department before running this utility for all departments. You can do this by filtering the report for a department, and then selecting “Refresh Data” to see the results of the summarization. You can also use the Quick Filter from the Main ribbon tab to limit the data set to review. Once you are comfortable with your coding, remove the filter, and from the Main ribbon, click Saveb.
In the File Processing task pane, click Process file.

NOTE: You do not need to run this utility using Multipass unless you are a large health system and are noting performance issues when previously running.

The report calculates monthly volume multiplied by the RVU for all statistics listed as KeyStat =”Yes” in the CDMCODE dimension.

TIP: The system populates the key departmental statistics into the ACT20XX table, which are available to view in Open in Spreadsheet mode or by running any standard KHA report that contains key departmental statistics.